/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-23 01:51:59
*/


-- ----------------------------
-- Table structure for tb0051
-- ----------------------------
DROP TABLE [dbo].[tb0051]
GO
CREATE TABLE [dbo].[tb0051] (
[ID] int IDENTITY(1,1) NOT NULL,
[PaymentTermID] varchar(20) NOT NULL ,
[PaymentTermName] nvarchar(150) NULL ,
[IsDueDate] tinyint NOT NULL DEFAULT ((0)) ,
[DueType] varchar(50) NULL ,
[DueDays] int NULL ,
[IsDiscount] tinyint NOT NULL DEFAULT ((0)) ,
[DiscountType] varchar(50) NULL ,
[DiscountPercentage] money NULL ,
[DiscountDays] int NULL ,
[Disabled] tinyint NOT NULL DEFAULT ((0)) ,
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[LastModifyUserID] varchar(20) NULL ,
[TheDay] tinyint NULL ,
[TheMonth] tinyint NULL ,
[CloseDay] tinyint NULL 
)


GO

-- ----------------------------
-- Indexes structure for table tb0051
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0051
-- ----------------------------
ALTER TABLE [dbo].[tb0051] ADD PRIMARY KEY NONCLUSTERED ([PaymentTermID])
GO

-- ----------------------------
-- Records of tb0051
-- ----------------------------
INSERT INTO [dbo].[tb0051] ([PaymentTermID], [PaymentTermName], [IsDueDate], [DueType], [DueDays], [IsDiscount], [DiscountType], [DiscountPercentage], [DiscountDays], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID], [TheDay], [TheMonth], [CloseDay]) VALUES (N'A1', N'A1', N'1', N'02', N'0', N'1', N'02', N'.0000', N'0', N'0', N'2013-09-24 01:51:52.387', N'ADMIN', N'2013-09-24 01:51:52.387', N'ADMIN', null, null, null)
GO
GO


